use "$path\datasets\rd_dataset.dta", clear

local depvar "ch_total_child_places_pc"

gen sum_elected_female_ex_last=sum_elected_female
bysort gkz jahr: egen sum_margin_women=sum(elected_women)
replace sum_elected_female_ex_last=sum_elected_female_ex_last-1 if elected_women==1


preserve
keep if  sum_elected_female_ex_last==0 
bandwidth_and_weights, depvar(`depvar') var(margin_1)  bwmethod(CCT) kernel(tri) degree(1) number_of_elec(num_of_obs)
ivreg2 `depvar' elected_women margin_1 inter_1   if abs(margin_1)<$bw_opt  [pw=weight] , r cluster(gkz ) partial(margin_1 inter_1 )
est store m1
estadd local bw "CCT"
estadd local degree "Linear"
estadd local bw_length  $bw_opt
unique gkz_legis_party if e(sample)
estadd local num_of_elections  `"`r(sum)'"'
sum `depvar' if e(sample)
estadd scalar  mean_depvar =r(mean)
estadd scalar sd_depvar =r(sd)
restore


preserve
keep if  sum_elected_female_ex_last==1
bandwidth_and_weights, depvar(`depvar') var(margin_1)  bwmethod(CCT) kernel(tri) degree(1) number_of_elec(num_of_obs)
ivreg2 `depvar' elected_women margin_1 inter_1   if abs(margin_1)<$bw_opt  [pw=weight] , r cluster(gkz ) partial(margin_1 inter_1 )
est store m2
estadd local bw "CCT"
estadd local degree "Linear"
estadd local bw_length  $bw_opt
unique gkz_legis_party if e(sample)
estadd local num_of_elections  `"`r(sum)'"'
sum `depvar' if e(sample)
estadd scalar  mean_depvar =r(mean)
estadd scalar sd_depvar =r(sd)
restore

preserve
keep if  sum_elected_female_ex_last==2
bandwidth_and_weights, depvar(`depvar') var(margin_1)  bwmethod(CCT) kernel(tri) degree(1) number_of_elec(num_of_obs)
ivreg2 `depvar' elected_women margin_1 inter_1   if abs(margin_1)<$bw_opt  [pw=weight] , r cluster(gkz ) partial(margin_1 inter_1 )
est store m3
estadd local bw "CCT"
estadd local degree "Linear"
estadd local bw_length  $bw_opt
unique gkz_legis_party if e(sample)
estadd local num_of_elections  `"`r(sum)'"'
sum `depvar' if e(sample)
estadd scalar  mean_depvar =r(mean)
estadd scalar sd_depvar =r(sd)
restore


preserve
keep if  sum_elected_female_ex_last==3
bandwidth_and_weights, depvar(`depvar') var(margin_1)  bwmethod(CCT) kernel(tri) degree(1) number_of_elec(num_of_obs)
ivreg2 `depvar' elected_women margin_1 inter_1   if abs(margin_1)<$bw_opt  [pw=weight] , r cluster(gkz ) partial(margin_1 inter_1 )
est store m4
estadd local bw "CCT"
estadd local degree "Linear"
estadd local bw_length  $bw_opt
unique gkz_legis_party if e(sample)
estadd local num_of_elections  `"`r(sum)'"'
sum `depvar' if e(sample)
estadd scalar  mean_depvar =r(mean)
estadd scalar sd_depvar =r(sd)
restore


preserve
keep if  sum_elected_female_ex_last==4
bandwidth_and_weights, depvar(`depvar') var(margin_1)  bwmethod(CCT) kernel(tri) degree(1) number_of_elec(num_of_obs)
ivreg2 `depvar' elected_women margin_1 inter_1   if abs(margin_1)<$bw_opt  [pw=weight] , r cluster(gkz ) partial(margin_1 inter_1 )
est store m5
estadd local bw "CCT"
estadd local degree "Linear"
estadd local bw_length  $bw_opt
unique gkz_legis_party if e(sample)
estadd local num_of_elections  `"`r(sum)'"'
sum `depvar' if e(sample)
estadd scalar  mean_depvar =r(mean)
estadd scalar sd_depvar =r(sd)
restore



preserve
keep if  sum_elected_female_ex_last==0 | sum_elected_female_ex_last==1 | sum_elected_female_ex_last==2 | sum_elected_female_ex_last==3
bandwidth_and_weights, depvar(`depvar') var(margin_1)  bwmethod(CCT) kernel(tri) degree(1) number_of_elec(num_of_obs)
ivreg2 `depvar' elected_women margin_1 inter_1   if abs(margin_1)<$bw_opt  [pw=weight] , r cluster(gkz ) partial(margin_1 inter_1 )
est store m6
estadd local bw "CCT"
estadd local degree "Linear"
estadd local bw_length  $bw_opt
unique gkz_legis_party if e(sample)
estadd local num_of_elections  `"`r(sum)'"'
sum `depvar' if e(sample)
estadd scalar  mean_depvar =r(mean)
estadd scalar sd_depvar =r(sd)
restore


preserve
keep if  sum_elected_female_ex_last>=4 & sum_elected_female_ex_last<.
bandwidth_and_weights, depvar(`depvar') var(margin_1)  bwmethod(CCT) kernel(tri) degree(1) number_of_elec(num_of_obs)
ivreg2 `depvar' elected_women margin_1 inter_1   if abs(margin_1)<$bw_opt  [pw=weight] , r cluster(gkz ) partial(margin_1 inter_1 )
est store m7
estadd local bw "CCT"
estadd local degree "Linear"
estadd local bw_length  $bw_opt
unique gkz_legis_party if e(sample)
estadd local num_of_elections  `"`r(sum)'"'
sum `depvar' if e(sample)
estadd scalar  mean_depvar =r(mean)
estadd scalar sd_depvar =r(sd)
restore

********************************************************************************************************************************************



esttab  m1 m2 m3 m4 m5 m6 m7 using Table5/table5_PanelA.txt, style(tab) replace order( ) mlabel(,none) ///
cells(b(label(coef.) star fmt(%8.3f) ) se(label((z)) par fmt(%6.3f))) ///
collabels(none) ///
keep (elected_women  ) ///
stats(bw bw_length degree N   N_clust mean_depvar sd_depvar , layout( @ @ @ @ @  `""@ (@)""' )  fmt( %~#s %9.2f %~# %9.0g %9.0g  %9.2f %9.2f  ) ///
labels("Bandwidth type" "Bandwidth size" "Polynomial"   "N"  "Municipalities" "Mean (SD)"  )) ///
starlevels(* 0.10 ** 0.05 *** 0.01) ///
varlabels( elected_women "Female victory"   ) 



